2014-05-07 - 12560.100 - Rel Notes - Time Zone reporting - Release 001 #BIReleases2014

Release Notes

12560.100 - Time Zone reporting

Admin Info

Purpose	Need to build region specific partitions in BW for regional reporting
Release No	001
Submitted	05/07/2014
Submitted by	Chandramouli K
Source/Destination Systems	BPD to BPQ to BPP
Release Sent To	Ashwin Kucheriya
Object(s) Created By	Chandramouli K
Object(s) Tested By	Chandramouli K

Transport and Technical Objects

SNo	Transport ID	Description	Object Name
1	BPDK901454	BW: SPO for Contract Source (Z_CNTR).	Z_CNTR00, Z_CNTR
2	BPDK901456	BW: SPO Source for Open Order (Z_OPN)	Z_OPN00, Z_OPN
3	BPDK901458	BW: SPO for COPA Source (Z_COPA)	Z_COPA00, Z_COPA
4	BPDK901460	BW: SPO for Condition Source (Z_COND)	Z_COND00, Z_COND
5	BPDK901462	BW: DTP's for Contract SPO source (Z_CNTR)	Z_CNTR Source DTP's.
6	BPDK901464	BW: DTP's for Open Order SPO Source (Z_OPN)	Z_OPN Source DTP's
7	BPDK901466	BW: DTP's for COPA SPO Source (Z_COPA)	Z_COPA Source DTP's
8	BPDK901468	BW: DTP's for Condition SPO Source (Z_COND)	Z_COND Source DTP's

Release Notes

For Infrastructure

The above transport requests mentioned in the above sequence need to be moved from BPD to BPQ and BPP.

For Requestor

1. First Transport will move the Contract Source SPO.
2. Second Transport will move Open Order Source SPO.
3. Third Transport will move COPA Source SPO.
4. Fourth Transport will move Condition Source SPO.
5. Fifth Transport will move DTPs for Contract Source SPO.
6. Sixth Transport will move DTPs for Open Order Source SPO.
7. Seventh Transport will move DTPs for COPA Source SPO.
8. Eighth Transport will move DTPs for Condition Source SPO.

Test Notes

1. Copa SPO Test Case:

SNo	Test Scenario	Expected Results
1	Check if all the characteristic values are populated & validated in COPA source SPO for each region.	All the characteristic values should be populated & Validated correctly for each region.
2	Check if the Key figures are populated & validated in COPA source SPO for each region.	All the Key figures should be populated & Validated correctly for each region.
3	Check if all the Navigational Attributes are populated & validated in COPA source SPO for each region.	All the Navigational Attributes should be populated & Validated correctly for each region.

Tested Orders for above three test Cases :

North America	Pass/Fail	Emerging Markets	Pass/Fail	EMEA	Pass/Fail	Japan
0000003584	P	0000065763	P	0000000985	P	No Test Data
0000007620	P	0000065188	P	0000003880	P	No Test Data
0000006673	P	0000065028	P	0000004831	P	No Test Data
0000011391	P	0000012883	P	0000005716	P	No Test Data
0000004192	P	0060000494	P	0000012903	P	No Test Data

2. Open Order SPO Test Case:

SNo	Test Scenario	Expected Results
1	Check if all the characteristic values are populated & validated in Open Order source SPO for each region.	All the characteristic values should be populated & Validated correctly for each region.
2	Check if all the Key figures are populated & validated in Open Order source SPO for each region.	All the Key figure values should be populated & Validated correctly for each region
3	Check if the all the Navigational Attributes are populated & validated in Open Order source SPO for each region.	All the Navigational Attributes should be populated & Validated correctly for each region.

Tested Orders for Above three Test Cases:

North America	Pass/Fail	Emerging Markets	Pass/Fail	EMEA	Pass/Fail	Japan
0000002728	P	0000012738	P	0000000365	P	No Test Data
0000038795	P	0000013307	P	0000001488	P	No Test Data
0000058812	P	0000055570	P	0000008448	P	No Test Data
0000059623	P	0000055696	P	0000012040	P	No Test Data
0000060180	P	0000066180	P	0000055087	P	No Test Data

3. Contract Orders SPO Test Case:

SNo	Test Scenario	Expected Results
1	Check if all the characteristic values are populated & validated in Contract Orders source SPO for each region.	All the characteristic values should be populated & Validated correctly for each region
2	Check if all the Key figures are populated & validated in Contract Orders source SPO for each region.	All the Key figure values should be populated & Validated correctly for each region.
3	Check if all the Navigational Attributes are populated & validated in Contract Orders source SPO for each region.	All the Navigational Attributes should be populated & Validated correctly for each region.

Tested Orders for Above three Test Cases:

North America	Pass/Fail	Emerging Markets	Pass/Fail	EMEA	Pass/Fail	Japan
0040000008	P	0040000453	P	0040000019	P	No Test Data
0040000369	P	0040000388	P	0040000044	P	No Test Data
0040000528	P	0040000507	P	0040000045	P	No Test Data

4. Condition Data SPO Test Case:

SNo	Test Scenario	Expected Results
1	Check if all the characteristic values are populated & validated in Condition data source SPO for each region.	All the characteristic values should be populated & Validated correctly for each region.
2	Check if all the Key figures are populated & validated in Condition data source SPO for each region.	All the Key figure values should be populated & Validated correctly for each region.
3	Check if all the Navigational Attributes are populated & validated in Condition data source SPO for each region.	All the Navigational Attributes should be populated & Validated correctly for each region.

Tested Orders for Above three Test Cases:

North America	Pass/Fail	Emerging Markets	Pass/Fail	EMEA	Pass/Fail	Japan
0000000207	P	0000012644	P	0000000757	P	No Test Data
0000026063	P	0000053805	P	0000001250	P	No Test Data
0000043045	P	0000054847	P	0000001331	P	No Test Data
0000055287	P	0000065170	P	0000015284	P	No Test Data
0000062412	P	0040000507	P	0000064707	P	No Test Data

Reference Document(Specification)

2014-04-21 - 12560.100 - Spec - Time Zone reporting